<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body bgcolor="00ccff" text="#000000">
 <form name="form1" method="post" action="getPReport.jsp">
<%@ page import ="java.sql.*"%>
<%
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 	Connection con=DriverManager.getConnection("jdbc:odbc:psi","psi","psi");
 	Statement st=con.createStatement();
 	ResultSet rs=st.executeQuery("select * from project"); 	
 %>

  <h2 align="center"><font face="Arial, Helvetica, sans-serif" color="#993300">Project 
    Status Report</font> </h2>
  <p align="center">&nbsp;</p>
  <p align="center">&nbsp; </p>
  <table width="28%" border="0" align="center">
    <tr> 
      <td width="54%">ProjectCode: </td>
      <td width="46%"> 
        <select name="projcode" size="1">
          <%while (rs.next()){%>
          <option><%=rs.getString(1)%></option>
          <%}%>
        </select>
      </td>
    </tr>
    <tr> 
      <td width="54%">&nbsp;</td>
      <td width="46%">&nbsp; </td>
    </tr>
    <tr>
      <td width="54%">&nbsp;</td>
      <td width="46%">
        <input type="submit" name="Submit" value="Submit">
      </td>
    </tr>
  </table>
</form>
  <h2 align="left">&nbsp;</h2>
  <h2 align="left">&nbsp; </h2>

</body>
</html>
